Text is truncated when exported to Excel because text exceeds Excel limit.

Cause:


This problem occurs when exporting Access tables or queries to MS Excel and is because the length of text in an Access field exceeds the 255-character cell limit in Excel.

Solution:


As a workaround, export the table or query to MS Word.